Enter stock opening balances

Find this screen

Open: Settings > Opening balances > Stock > Opening Balances at Locations

How to

Enter opening balances

Enter balances separately for each warehouse. If your item's in more than one, you need to enter several opening balances.

  1. Choose a warehouse.
  2. In the grid, enter the number in stock in the Opening Quantity column.
  3. Enter the cost per item in the Unit Cost Price column.
  4. Repeat for all the stock items required.
  5. To save these balances, click OK.

You can return here and enter more opening balances as often as you want, but you can't enter a balance for the same item again

Add a new bin

If the item is stored in a different bin, you can add the bin here.

  1. Select a stock item from the list.
  2. Click New Bin for Stock Item.
  3. Enter a name for the bin
  4. Click OK.

Useful info

About stock opening balances

If you're moving from another system, and you want Sage 200 to keep track of your stock items and their value, then you'll need to enter an opening balance for each item. This updates the quantity in stock and updates your buying price (used to value your stock). You enter the balance for each warehouse and bin (if the item's stored in more than one).

You don't have to do this for all stock items in one go, although you can only enter the a balance for each warehouse and bin, once. Doing this doesn't post any values to your nominal accounts, as this will have been included in your opening trial balance, if you've entered one.

If you've already got a list of your current stock levels, on an Excel spreadsheet for example, you can import your opening balances via a CSV file.

Things to consider

  • You can only do this for Stock type items (not Service / Labour or Miscellaneous).
  • You can only enter this once for each stock item.
  • Once a balance has been entered, the item is shown in grey text.
  • If the item's stored in more than one warehouse or bin, enter a balance for each item at each warehouse and bin.
  • If you enter a cost price, this updates the Average Buying Price and is used to value the stock.
  • This doesn't post a value to your nominal accounts.
  • You don't have to enter a balance for all items.
  • You can come back to this form as often as you need to.

Importing opening balances

If you have a lot of opening balances to enter, consider importing them. You can only import an opening balance once per stock item per warehouse or bin.

The stock item must already exist and be stored in the specified warehouse(s). If you have opening balances for stock items that are stored in bins that you haven't yet created in Sage 200, you can choose to allow Sage 200 to create the bins from the import file.

See Import stock opening balances.


What happens when

What happens when I enter opening balances?

  1. An opening balance transaction is added to the stock history.

    Note: Your nominal accounts are not updated.

  2. The quantity in stock is updated.
  3. The cost price is updated.